﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Interface_Tier;
using Transfer_Object_Tier;
using System.Data;
using Data_Access_Tier;

namespace Business_Tier
{
    public class BT_NhanVien : MarshalByRefObject, INhanVien
    {
        DataSet dt = null;
        HRM_EMPLOYEEData emp = new HRM_EMPLOYEEData();

        public int NHAN_VIEN_THEM(HRM_EMPLOYEE NHAN_VIEN)
        {
            return emp.HRM_EMPLOYEE_Insert(NHAN_VIEN);

        }
        public int NHAN_VIEN_CAP_NHAT(HRM_EMPLOYEE NHAN_VIEN) 
        {
            return emp.HRM_EMPLOYEE_Update(NHAN_VIEN);
        }
        public int NHAN_VIEN_CAP_NHAT_HOP_DONG(HRM_EMPLOYEE NHAN_VIEN)
        {
            return 1;
        }
        public int NHAN_VIEN_CAP_NHAT_MA_CHAM_CONG(string MA_CHAM_CONG, string MA_NHAN_VIEN)
        {
            return 1;
        }
        public int NHAN_VIEN_XOA(string MA_NV)
        {
            return emp.HRM_EMPLOYEE_Delete(MA_NV);
        }

        public DataSet LAY_DS_NHAN_VIEN_THEO_TINH_TRANG(int TINH_TRANG, DateTime NGAY_BAT_DAU_CUA_THANG, DateTime NGAY_CUOI_CUNG_CUA_THANG)
        {
            return emp.HRM_EMPLOYEE_GetList(TINH_TRANG, NGAY_BAT_DAU_CUA_THANG, NGAY_CUOI_CUNG_CUA_THANG);
        }
        public DataSet LAY_TOAN_BO_DS_NHAN_VIEN()
        {
            return emp.HRM_EMPLOYEE_GetListAll();
        }

        public DataSet LAY_THONG_TIN_NHAN_VIEN(string MA_NV)
        {
            return emp.HRM_EMPLOYEE_Get(MA_NV);
        }
        public DataSet LAY_THONG_TIN_NHAN_VIEN_THEO_MA_CHAM_CONG(string MA_CHAM_CONG)
        {
            return emp.HRM_EMPLOYEE_Get(MA_CHAM_CONG);
        }

        public int LAY_SL_NHAN_VIEN()
        {
            return 1;
        }
        public DataSet THONG_KE_NHAN_VIEN_THEO_DO_TUOI()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_NHAN_VIEN_THEO_GIOI_TINH()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_NHAN_VIEN_THEO_TRINH_DO()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_NHAN_VIEN_THEO_DAN_TOC()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_NHAN_VIEN_THEO_HON_NHAN()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_NHAN_VIEN_THEO_NUOC()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_TONG_QUAN()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_TINH_TRANG_LAM_VIEC()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_NHAN_VIEN_THEO_TON_GIAO()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_NHAN_VIEN_THEO_VI_TRI_CONG_VIEC()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet THONG_KE_GIA_TANG_SL_NHAN_VIEN_THEO_NAM(string TU_NAM, string DEN_NAM)
        {
            dt = new DataSet();
            return dt;
        }


        public DataSet LAY_DS_NHAN_VIEN_THEO_NGAY_SINH_HOM_NAY()
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet LAY_DS_NHAN_VIEN_THEO_THANG_SINH(string THANG)
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet LAY_DS_NHAN_VIEN_THEO_CHI_NHANH(string MA_CHI_NHANH, string TINH_TRANG, string NGAY_BAT_DAU_CUA_THANG, string NGAY_CUOI_CUNG_CUA_THANG)
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet LAY_DS_NHAN_VIEN_THEO_PHONG_BAN(string MA_PHONG_BAN, string TINH_TRANG, string NGAY_BAT_DAU_CUA_THANG, string NGAY_CUOI_CUNG_CUA_THANG)
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet LAY_DS_NHAN_VIEN_THEO_TO_NHOM(string MA_TO_NHOM, string TINH_TRANG, string NGAY_BAT_DAU_CUA_THANG, string NGAY_CUOI_CUNG_CUA_THANG)
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet LAY_DS_NHAN_VIEN_THEO_NAM(string NAM)
        {
            dt = new DataSet();
            return dt;
        }
        public DataSet HRM_EMPLOYEE_Count()
        {
            return emp.HRM_EMPLOYEE_Count();
        }
        public DataSet HRM_EMPLOYEE_GetAge()
        {
            return emp.HRM_EMPLOYEE_GetAge();
        }
        public DataSet HRM_EMPLOYEE_GetAllSex()
        {
            return emp.HRM_EMPLOYEE_GetAllSex();
        }
        public DataSet HRM_EMPLOYEE_GetByEnroll(String EnrollNumber)
        {
            return emp.HRM_EMPLOYEE_GetByEnroll(EnrollNumber);
        }
        public DataSet HRM_EMPLOYEE_GetEducation()
        {
            return emp.HRM_EMPLOYEE_GetEducation();
        }
        public DataSet HRM_EMPLOYEE_GetEthnic()
        {
            return emp.HRM_EMPLOYEE_GetEthnic();
        }
        public DataSet HRM_EMPLOYEE_GetIncreaseDecreaseList(int Level, String Code,int Status, int Month, int Year)
        {
            return emp.HRM_EMPLOYEE_GetIncreaseDecreaseList(Level, Code, Status, Month, Year);
        }
        public DataSet HRM_EMPLOYEE_GetListBirthday()
        {
            return emp.HRM_EMPLOYEE_GetListBirthday();
        }
        public DataSet HRM_EMPLOYEE_GetListBirthdayByMonth(int Month)
        {
            return emp.HRM_EMPLOYEE_GetListBirthdayByMonth(Month);
        }
        public DataSet HRM_EMPLOYEE_GetListByBranch(String BranchCode, int Status, DateTime DayFirstMonth, DateTime DayEndMonth)
        {
            return emp.HRM_EMPLOYEE_GetListByBranch(BranchCode, Status, DayFirstMonth, DayEndMonth);
        }
        public DataSet HRM_EMPLOYEE_GetListByDepartment(String DepartmentCode, int Status, DateTime DayFirstMonth, DateTime DayEndMonth)
        {
            return emp.HRM_EMPLOYEE_GetListByDepartment(DepartmentCode, Status, DayFirstMonth, DayEndMonth);
        }
        public DataSet HRM_EMPLOYEE_GetListByGroup(String GroupCode, int Status, DateTime DayFirstMonth, DateTime DayEndMonth)
        {
            return emp.HRM_EMPLOYEE_GetListByGroup(GroupCode, Status, DayFirstMonth, DayEndMonth);
        }
        public DataSet HRM_EMPLOYEE_GetListByYear(int Year)
        {
            return emp.HRM_EMPLOYEE_GetListByYear(Year);
        }
        public DataSet HRM_EMPLOYEE_GetMarriage()
        {
            return emp.HRM_EMPLOYEE_GetMarriage();
        }
        public DataSet HRM_EMPLOYEE_GetNationality()
        {
            return emp.HRM_EMPLOYEE_GetNationality();
        }
        public DataSet HRM_EMPLOYEE_GetPosition()
        {
            return emp.HRM_EMPLOYEE_GetPosition();
        }
        public DataSet HRM_EMPLOYEE_GetRate(int FromYear, int ToYear)
        {
            return emp.HRM_EMPLOYEE_GetRate(FromYear, ToYear);
        }
        public DataSet HRM_EMPLOYEE_GetReligion()
        {
            return emp.HRM_EMPLOYEE_GetReligion();
        }
        public DataSet HRM_EMPLOYEE_GetSex()
        {
            return emp.HRM_EMPLOYEE_GetSex();
        }
        public DataSet HRM_EMPLOYEE_GetStatistical()
        {
            return emp.HRM_EMPLOYEE_GetStatistical();
        }
        public DataSet HRM_EMPLOYEE_GetStatus()
        {
            return emp.HRM_EMPLOYEE_GetStatus();
        }




    }
}
